SUPPORT / SAMPLES & SAS NOTES
Problem Note 59661: The MAXDATA.CONFIG_QUERY_SYNTAX database query does not include Version_ID
 |  |  |  |
The SAS® Merchandise Allocation MAXDATA.CONFIG_QUERY_SYNTAX database query does not include Version_ID. If there is no Version_ID, then Allocation worksheets might seed with incorrect data.
To work around this issue, run the following update query in the database:
UPDATE MAXDATA.CONFIG_QUERY_SYNTAX SET QUERY_WHERE = 'WHERE m.cube_id = %CUBE_ID AND version_id=%HASHKEY_ID ORDER BY merch_level DESC'
WHERE QUERY_TYPE = 'ALLOC_ATTR_LG';
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Allocation | Microsoft® Windows® for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 | ||
| Linux for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 | ||